Introduction
R Session Info
R version 3.3.2 (2016-10-31)
Platform: x86_64-apple-darwin13.4.0 (64-bit)
Running under: OS X Yosemite 10.10.5
locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] data.world_0.1.2 dplyr_0.5.0 plyr_1.8.4 readr_1.1.0
loaded via a namespace (and not attached):
[1] Rcpp_0.12.10 knitr_1.15.1 magrittr_1.5 hms_0.3 R6_2.2.0 stringr_1.1.0 httr_1.2.1 tools_3.3.2
[9] DBI_0.5-1 htmltools_0.3.5 yaml_2.1.14 lazyeval_0.2.0 assertthat_0.1 digest_0.6.11 rprojroot_1.1 tibble_1.3.0
[17] base64enc_0.1-3 rsconnect_0.7 curl_2.3 evaluate_0.10 rmarkdown_1.3 stringi_1.1.2 backports_1.0.4 jsonlite_1.3
Description
This notebook documents the education attainment levels and age-adjusted death rates (AADR) for different causes of death across the United States. The data has been organized to explore the relationship between education attainment and AAMR between 1999 and 2013.
Data
How to download dataset from Data.World:
- Log into your account on https://data.world/
- Under the Datasets tab, go to “S17 eDV Project 6”
- Scroll down until you reach “Death.csv”
- Click on download
- Save the file under a folder accessible by Tableau
ETL Script
Visualizations
Tableau
Barchart - AADR by State
Barchart displays the sum of the AADR per cause across the United States. Heart Disease and Cancer have consistently higher sums of AADR than the average AADR for all causes.
Barchart - AADR by Year
Barchart displays the sum of the AADR per cause from 1999-2013. The average sum of AADR for all causes do not vary greatly per year. Heart Disease, Cancer, and Stroke have consistently higher sums of AADR than the average AADR for all causes.
Bachelor’s Degree Attainment: Female
High Level 
Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of female BS attainment (0.15-0.25). Compared to males, females also had a greater amount of states with high levels.
Low Level 
Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of female BS attainment (<0.15).
Bachelor’s Degree Attainment: Male
High Level 
Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of male BS attainment (0.15-0.25).
Low Level 
Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of male BS attainment (<0.15).
Shiny
Barchart - AADR by State
Barchart displays the sum of the AADR per cause across the United States. Heart Disease and Cancer have consistently higher sums of AADR than the average AADR for all causes.
Barchart - AADR by Year
Barchart displays the sum of the AADR per cause from 1999-2013. The average sum of AADR for all causes do not vary greatly per year. Heart Disease, Cancer, and Stroke have consistently higher sums of AADR than the average AADR for all causes.
Bachelor’s Degree Attainment: Female
High Level 
Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of female BS attainment (0.15-0.25). Compared to males, females also had a greater amount of states with high levels.
Low Level 
Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of female BS attainment (<0.15).
Bachelor’s Degree Attainment: Male
High Level 
Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of male BS attainment (0.15-0.25).
Low Level 
Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of male BS attainment (<0.15).
LS0tCnRpdGxlOiAiQXNzb2NpYXRpb24gQmV0d2VlbiBBZ2UtQWRqdXN0ZWQgRGVhdGggUmF0ZSBhbmQgQmFjaGVsb3IncyBEZWdyZWUgQXR0YWlubWVudCIKYXV0aG9yOiAiTi4gSHVhLCBTLiBUcmFuLCBWLiBTaGFyYXRoLCBLLiBXYW5nIgpvdXRwdXQ6CiAgaHRtbF9kb2N1bWVudDoKICAgIHRvYzogeWVzCiAgaHRtbF9ub3RlYm9vazogZGVmYXVsdAogIHBkZl9kb2N1bWVudDogZGVmYXVsdAotLS0KIyAqKkludHJvZHVjdGlvbioqIAojIyMgKipSIFNlc3Npb24gSW5mbyoqCgpgYGB7ciBlY2hvPUZBTFNFfQpzZXNzaW9uSW5mbygpCmBgYAoKIyAqKkRlc2NyaXB0aW9uKioKVGhpcyBub3RlYm9vayBkb2N1bWVudHMgdGhlIGVkdWNhdGlvbiBhdHRhaW5tZW50IGxldmVscyBhbmQgYWdlLWFkanVzdGVkIGRlYXRoIHJhdGVzIChBQURSKSBmb3IgZGlmZmVyZW50IGNhdXNlcyBvZiBkZWF0aCBhY3Jvc3MgdGhlIFVuaXRlZCBTdGF0ZXMuIFRoZSBkYXRhIGhhcyBiZWVuIG9yZ2FuaXplZCB0byBleHBsb3JlIHRoZSByZWxhdGlvbnNoaXAgYmV0d2VlbiBlZHVjYXRpb24gYXR0YWlubWVudCBhbmQgQUFNUiBiZXR3ZWVuIDE5OTkgYW5kIDIwMTMuIAoKIyAqKkRhdGEqKgoqKkhvdyB0byBkb3dubG9hZCBkYXRhc2V0IGZyb20gRGF0YS5Xb3JsZDoqKgoKMS4gTG9nIGludG8geW91ciBhY2NvdW50IG9uIGh0dHBzOi8vZGF0YS53b3JsZC8KMi4gVW5kZXIgdGhlICpEYXRhc2V0cyogdGFiLCBnbyB0byAiUzE3IGVEViBQcm9qZWN0IDYiCjMuIFNjcm9sbCBkb3duIHVudGlsIHlvdSByZWFjaCAiRGVhdGguY3N2Igo0LiBDbGljayBvbiBkb3dubG9hZAo1LiBTYXZlIHRoZSBmaWxlIHVuZGVyIGEgZm9sZGVyIGFjY2Vzc2libGUgYnkgVGFibGVhdQoKIyAqKkVUTCBTY3JpcHQqKgpgYGAge3IgZWNobz1GQUxTRX0Kc291cmNlKCIuLi8wMSBEYXRhL0VUTF9TY3JpcHQuUiIpCmBgYAoKIyAqKlZpc3VhbGl6YXRpb25zKioKCiMjICoqVGFibGVhdSoqCgojIyMgKipCYXJjaGFydCAtIEFBRFIgYnkgU3RhdGUqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvQmFyY2hhcnRfQUFEUi5wbmcpPC9jZW50ZXI+CkJhcmNoYXJ0IGRpc3BsYXlzIHRoZSBzdW0gb2YgdGhlIEFBRFIgcGVyIGNhdXNlIGFjcm9zcyB0aGUgVW5pdGVkIFN0YXRlcy4KSGVhcnQgRGlzZWFzZSBhbmQgQ2FuY2VyIGhhdmUgY29uc2lzdGVudGx5IGhpZ2hlciBzdW1zIG9mIEFBRFIgdGhhbiB0aGUgYXZlcmFnZSBBQURSIGZvciBhbGwgY2F1c2VzLiAgCgoKIyMjICoqQmFyY2hhcnQgLSBBQURSIGJ5IFllYXIqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvWXItU3VtRGVhdGgtRGlmZi5wbmcpPC9jZW50ZXI+CkJhcmNoYXJ0IGRpc3BsYXlzIHRoZSBzdW0gb2YgdGhlIEFBRFIgcGVyIGNhdXNlIGZyb20gMTk5OS0yMDEzLiAKVGhlIGF2ZXJhZ2Ugc3VtIG9mIEFBRFIgZm9yIGFsbCBjYXVzZXMgZG8gbm90IHZhcnkgZ3JlYXRseSBwZXIgeWVhci4KSGVhcnQgRGlzZWFzZSwgQ2FuY2VyLCBhbmQgU3Ryb2tlIGhhdmUgY29uc2lzdGVudGx5IGhpZ2hlciBzdW1zIG9mIEFBRFIgdGhhbiB0aGUgYXZlcmFnZSBBQURSIGZvciBhbGwgY2F1c2VzLiAgCgojIyMgKipCYWNoZWxvcidzIERlZ3JlZSBBdHRhaW5tZW50OiBGZW1hbGUqKgoKKipIaWdoIExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0ZfSGlnaF9CUy5wbmcpPC9jZW50ZXI+CkJhcmNoYXJ0IGRpc3BsYXlzIGZlbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGhpZ2ggbGV2ZWxzIG9mIGZlbWFsZSBCUyBhdHRhaW5tZW50ICgwLjE1LTAuMjUpLgpDb21wYXJlZCB0byBtYWxlcywgZmVtYWxlcyBhbHNvIGhhZCBhIGdyZWF0ZXIgYW1vdW50IG9mIHN0YXRlcyB3aXRoIGhpZ2ggbGV2ZWxzLiAKCioqTG93IExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0ZfTG93X0JTLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIGZlbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGxvdyBsZXZlbHMgb2YgZmVtYWxlIEJTIGF0dGFpbm1lbnQgKDwwLjE1KS4KCiMjIyAqKkJhY2hlbG9yJ3MgRGVncmVlIEF0dGFpbm1lbnQ6IE1hbGUqKgoKKipIaWdoIExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL01fSGlnaF9CUy5wbmcpPC9jZW50ZXI+IApCYXJjaGFydCBkaXNwbGF5cyBtYWxlcyB3aG8ndmUgYXR0YWluZWQgYSBCYWNoZWxvcidzIERlZ3JlZS4gClRoZSBwYWdlIG9ubHkgc2hvd3MgdGhlIHNldCBvZiBzdGF0ZXMgdGhhdCBob3N0ZWQgaGlnaCBsZXZlbHMgb2YgbWFsZSBCUyBhdHRhaW5tZW50ICgwLjE1LTAuMjUpLgoKKipMb3cgTGV2ZWwqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvTV9Mb3dfQlMucG5nKTwvY2VudGVyPiAKQmFyY2hhcnQgZGlzcGxheXMgbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGxvdyBsZXZlbHMgb2YgbWFsZSBCUyBhdHRhaW5tZW50ICg8MC4xNSkuCgoKIyMgKipTaGlueSoqCiMjIyMgKipQdWJsaXNoZWQgU2hpbnkgYXBwIGxpbmsqKgpodHRwczovL3N0ZXZlbnRyYW4uc2hpbnlhcHBzLmlvL3Byb2plY3Q2X3NoaW55LwoKIyMjICoqQmFyY2hhcnQgLSBBQURSIGJ5IFN0YXRlKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL3NoaW55X3N0YXRlX2FhZHIucG5nKTwvY2VudGVyPiAKQmFyY2hhcnQgZGlzcGxheXMgdGhlIHN1bSBvZiB0aGUgQUFEUiBwZXIgY2F1c2UgYWNyb3NzIHRoZSBVbml0ZWQgU3RhdGVzLgpIZWFydCBEaXNlYXNlIGFuZCBDYW5jZXIgaGF2ZSBjb25zaXN0ZW50bHkgaGlnaGVyIHN1bXMgb2YgQUFEUiB0aGFuIHRoZSBhdmVyYWdlIEFBRFIgZm9yIGFsbCBjYXVzZXMuICAKCiMjIyAqKkJhcmNoYXJ0IC0gQUFEUiBieSBZZWFyKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL3NoaW55X3lyX2FhZHIucG5nKTwvY2VudGVyPiAKQmFyY2hhcnQgZGlzcGxheXMgdGhlIHN1bSBvZiB0aGUgQUFEUiBwZXIgY2F1c2UgZnJvbSAxOTk5LTIwMTMuIApUaGUgYXZlcmFnZSBzdW0gb2YgQUFEUiBmb3IgYWxsIGNhdXNlcyBkbyBub3QgdmFyeSBncmVhdGx5IHBlciB5ZWFyLgpIZWFydCBEaXNlYXNlLCBDYW5jZXIsIGFuZCBTdHJva2UgaGF2ZSBjb25zaXN0ZW50bHkgaGlnaGVyIHN1bXMgb2YgQUFEUiB0aGFuIHRoZSBhdmVyYWdlIEFBRFIgZm9yIGFsbCBjYXVzZXMuICAKCiMjIyAqKkJhY2hlbG9yJ3MgRGVncmVlIEF0dGFpbm1lbnQ6IEZlbWFsZSoqCgoqKkhpZ2ggTGV2ZWwqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvc2hpbnlfaGlnaF9mYnMucG5nKTwvY2VudGVyPgpCYXJjaGFydCBkaXNwbGF5cyBmZW1hbGVzIHdobyd2ZSBhdHRhaW5lZCBhIEJhY2hlbG9yJ3MgRGVncmVlLiAKVGhlIHBhZ2Ugb25seSBzaG93cyB0aGUgc2V0IG9mIHN0YXRlcyB0aGF0IGhvc3RlZCBoaWdoIGxldmVscyBvZiBmZW1hbGUgQlMgYXR0YWlubWVudCAoMC4xNS0wLjI1KS4KQ29tcGFyZWQgdG8gbWFsZXMsIGZlbWFsZXMgYWxzbyBoYWQgYSBncmVhdGVyIGFtb3VudCBvZiBzdGF0ZXMgd2l0aCBoaWdoIGxldmVscy4gCgoqKkxvdyBMZXZlbCoqCiFbXSguLi8wMyBWaXN1YWxpemF0aW9ucy9zaGlueV9sb3dfZmJzLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIGZlbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGxvdyBsZXZlbHMgb2YgZmVtYWxlIEJTIGF0dGFpbm1lbnQgKDwwLjE1KS4KCiMjIyAqKkJhY2hlbG9yJ3MgRGVncmVlIEF0dGFpbm1lbnQ6IE1hbGUqKgoKKipIaWdoIExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL3NoaW55X2hpZ2hfbWJzLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIG1hbGVzIHdobyd2ZSBhdHRhaW5lZCBhIEJhY2hlbG9yJ3MgRGVncmVlLiAKVGhlIHBhZ2Ugb25seSBzaG93cyB0aGUgc2V0IG9mIHN0YXRlcyB0aGF0IGhvc3RlZCBoaWdoIGxldmVscyBvZiBtYWxlIEJTIGF0dGFpbm1lbnQgKDAuMTUtMC4yNSkuCgoqKkxvdyBMZXZlbCoqCiFbXSguLi8wMyBWaXN1YWxpemF0aW9ucy9zaGlueV9sb3dfbWJzLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIG1hbGVzIHdobyd2ZSBhdHRhaW5lZCBhIEJhY2hlbG9yJ3MgRGVncmVlLiAKVGhlIHBhZ2Ugb25seSBzaG93cyB0aGUgc2V0IG9mIHN0YXRlcyB0aGF0IGhvc3RlZCBsb3cgbGV2ZWxzIG9mIG1hbGUgQlMgYXR0YWlubWVudCAoPDAuMTUpLgoKIyAqKlNoaW55IExpbmsqKgpodHRwczovL3N0ZXZlbnRyYW4uc2hpbnlhcHBzLmlvL3Byb2plY3Q2X3NoaW55LwoK